<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RepeaterPage.aspx.cs" Inherits="RepeaterPage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RecruitVietnamDbConnectionString %>"
            SelectCommand="SELECT [RecruiterID], [Email], [CompanyName], [ContactName], [Address], [Phone] FROM [tblRCAccounts]">
        </asp:SqlDataSource>
    
    </div>
        <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" DataMember="DefaultView">
          <HeaderTemplate>
             <table border="1">
                <tr>
                   <td><b>Email</b></td>
                   <td><b>CompanyName</b></td>
                   <td><b>Address</b></td>
                </tr>
          </HeaderTemplate>
             
          <ItemTemplate>
             <tr>
                <td> <%# DataBinder.Eval(Container.DataItem, "Email") %> </td>
                <td><asp:Label runat="server" ID="Label1" Text='<%# Bind("CompanyName") %>' /> </td>
                <td> <asp:Label runat="server" ID="Label3" Text='<%# Eval("Address") %>' /></td>
             </tr>
          </ItemTemplate>
             
          <FooterTemplate>
             </table>
          </FooterTemplate>
  
        </asp:Repeater>
        &nbsp;
    </form>
</body>
</html>
